from database import db


class Activity(db.Model):
    __tablename__ = 'Activity'

    id = db.Column(db.INTEGER(), primary_key=True)
    name = db.Column(db.String(100, 'utf8mb4_unicode_ci'), nullable=False)
    descr = db.Column(db.String(255, 'utf8mb4_unicode_ci'), nullable=False)
    img = db.Column(db.Text(collation='utf8mb4_unicode_ci'), nullable=False)
    status = db.Column(db.INTEGER(), nullable=False)
    date1 = db.Column(db.Date, nullable=False)
    date2 = db.Column(db.Time, nullable=False)
    timeline = db.Column(db.INTEGER(), nullable=False)
    time1 = db.Column(db.String(100, 'utf8mb4_unicode_ci'), nullable=False)
    desc1 = db.Column(db.String(100, 'utf8mb4_unicode_ci'), nullable=False)
    time2 = db.Column(db.String(100, 'utf8mb4_unicode_ci'), nullable=False)
    desc2 = db.Column(db.String(100, 'utf8mb4_unicode_ci'), nullable=False)
    time3 = db.Column(db.String(100, 'utf8mb4_unicode_ci'), nullable=False)
    desc3 = db.Column(db.String(100, 'utf8mb4_unicode_ci'), nullable=False)
    subimg = db.Column(db.INTEGER(), nullable=False)
    subimgurl = db.Column(db.Text(collation='utf8mb4_unicode_ci'), nullable=False)
    maindesc = db.Column(db.INTEGER(), nullable=False)
    maindescdata = db.Column(db.Text(collation='utf8mb4_unicode_ci'), nullable=False)
    
    
class Checkin(db.Model):
    __tablename__ = 'Checkin'

    id = db.Column(db.INTEGER(), primary_key=True)
    userid = db.Column(db.INTEGER(), nullable=False)
    actid = db.Column(db.INTEGER(), nullable=False)
    code = db.Column(db.String(100, 'utf8mb4_unicode_ci'), nullable=False)